USE JICCDB
GO
CREATE PROC proc_DelUser
@LoginID VARCHAR(16)
AS
DECLARE @count INT
SELECT @count = COUNT(*) FROM tab_User WHERE LoginID = @LoginID
IF(@count <> 1)
BEGIN
RETURN(2)
END
ELSE
BEGIN
DELETE tab_User WHERE LoginID = @LoginID
RETURN(0)
END
RETURN(1)
GO